Select
  ra.id,
  Format(ra.[Date], 'dd-mm-yyyy') As Boekdatum,
  ra.AmountInEuro,
  ra.Description,
  ra.RelationAccountWithoutDots,
  ra.FKOtherTransaction,
  Account.AccountNrWithoutDots,
  Account.Description As Description1
From
  ([Transaction] ra Inner Join
  [Transaction] rb On ra.FKOtherTransaction = rb.id) Inner Join
  Account On ra.FKAccount = Account.id
Where
  ra.FKOtherTransaction <> 0 And
  ra.id In (2495, 2496, 2778, 2779, 4031, 4032, 4033, 4034, 4036, 4037, 4040,
  4041, 7506, 7507, 7519, 7520, 7524, 7525)
Order By
  ra.id
